package cn.invest.merry.module.invest.dal.mysql.lrbase;

import java.util.*;

import cn.invest.merry.framework.common.pojo.PageResult;
import cn.invest.merry.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.invest.merry.framework.mybatis.core.mapper.BaseMapperX;
import cn.invest.merry.module.invest.dal.dataobject.lrbase.LrBaseDO;
import org.apache.ibatis.annotations.Mapper;
import cn.invest.merry.module.invest.controller.admin.lrbase.vo.*;

/**
 * 个股报告期利润 Mapper
 *
 * @author 芋道源码
 */
@Mapper
public interface LrBaseMapper extends BaseMapperX<LrBaseDO> {

    default PageResult<LrBaseDO> selectPage(LrBasePageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<LrBaseDO>()
                .eqIfPresent(LrBaseDO::getSeccode, reqVO.getSeccode())
                .likeIfPresent(LrBaseDO::getSecname, reqVO.getSecname())
                .likeIfPresent(LrBaseDO::getOrgname, reqVO.getOrgname())
                .betweenIfPresent(LrBaseDO::getDeclaredate, reqVO.getDeclaredate())
                .betweenIfPresent(LrBaseDO::getStartdate, reqVO.getStartdate())
                .betweenIfPresent(LrBaseDO::getEnddate, reqVO.getEnddate())
                .eqIfPresent(LrBaseDO::getF001d, reqVO.getF001d())
                .eqIfPresent(LrBaseDO::getF002v, reqVO.getF002v())
                .eqIfPresent(LrBaseDO::getF003v, reqVO.getF003v())
                .eqIfPresent(LrBaseDO::getF004v, reqVO.getF004v())
                .eqIfPresent(LrBaseDO::getF005v, reqVO.getF005v())
                .eqIfPresent(LrBaseDO::getF035n, reqVO.getF035n())
                .eqIfPresent(LrBaseDO::getF006n, reqVO.getF006n())
                .eqIfPresent(LrBaseDO::getF033n, reqVO.getF033n())
                .eqIfPresent(LrBaseDO::getF034n, reqVO.getF034n())
                .eqIfPresent(LrBaseDO::getF042n, reqVO.getF042n())
                .eqIfPresent(LrBaseDO::getF036n, reqVO.getF036n())
                .eqIfPresent(LrBaseDO::getF007n, reqVO.getF007n())
                .eqIfPresent(LrBaseDO::getF043n, reqVO.getF043n())
                .eqIfPresent(LrBaseDO::getF044n, reqVO.getF044n())
                .eqIfPresent(LrBaseDO::getF045n, reqVO.getF045n())
                .eqIfPresent(LrBaseDO::getF046n, reqVO.getF046n())
                .eqIfPresent(LrBaseDO::getF047n, reqVO.getF047n())
                .eqIfPresent(LrBaseDO::getF048n, reqVO.getF048n())
                .eqIfPresent(LrBaseDO::getF049n, reqVO.getF049n())
                .eqIfPresent(LrBaseDO::getF008n, reqVO.getF008n())
                .eqIfPresent(LrBaseDO::getF009n, reqVO.getF009n())
                .eqIfPresent(LrBaseDO::getF010n, reqVO.getF010n())
                .eqIfPresent(LrBaseDO::getF011n, reqVO.getF011n())
                .eqIfPresent(LrBaseDO::getF012n, reqVO.getF012n())
                .eqIfPresent(LrBaseDO::getF056n, reqVO.getF056n())
                .eqIfPresent(LrBaseDO::getF013n, reqVO.getF013n())
                .eqIfPresent(LrBaseDO::getF014n, reqVO.getF014n())
                .eqIfPresent(LrBaseDO::getF015n, reqVO.getF015n())
                .eqIfPresent(LrBaseDO::getF016n, reqVO.getF016n())
                .eqIfPresent(LrBaseDO::getF037n, reqVO.getF037n())
                .eqIfPresent(LrBaseDO::getF051n, reqVO.getF051n())
                .eqIfPresent(LrBaseDO::getF057n, reqVO.getF057n())
                .eqIfPresent(LrBaseDO::getF058n, reqVO.getF058n())
                .eqIfPresent(LrBaseDO::getF059n, reqVO.getF059n())
                .eqIfPresent(LrBaseDO::getF017n, reqVO.getF017n())
                .eqIfPresent(LrBaseDO::getF018n, reqVO.getF018n())
                .eqIfPresent(LrBaseDO::getF019n, reqVO.getF019n())
                .eqIfPresent(LrBaseDO::getF020n, reqVO.getF020n())
                .eqIfPresent(LrBaseDO::getF050n, reqVO.getF050n())
                .eqIfPresent(LrBaseDO::getF021n, reqVO.getF021n())
                .eqIfPresent(LrBaseDO::getF022n, reqVO.getF022n())
                .eqIfPresent(LrBaseDO::getF023n, reqVO.getF023n())
                .eqIfPresent(LrBaseDO::getF024n, reqVO.getF024n())
                .eqIfPresent(LrBaseDO::getF025n, reqVO.getF025n())
                .eqIfPresent(LrBaseDO::getF026n, reqVO.getF026n())
                .eqIfPresent(LrBaseDO::getF027n, reqVO.getF027n())
                .eqIfPresent(LrBaseDO::getF060n, reqVO.getF060n())
                .eqIfPresent(LrBaseDO::getF061n, reqVO.getF061n())
                .eqIfPresent(LrBaseDO::getF028n, reqVO.getF028n())
                .eqIfPresent(LrBaseDO::getF029n, reqVO.getF029n())
                .eqIfPresent(LrBaseDO::getF031n, reqVO.getF031n())
                .eqIfPresent(LrBaseDO::getF032n, reqVO.getF032n())
                .eqIfPresent(LrBaseDO::getF038n, reqVO.getF038n())
                .eqIfPresent(LrBaseDO::getF039n, reqVO.getF039n())
                .eqIfPresent(LrBaseDO::getF040n, reqVO.getF040n())
                .eqIfPresent(LrBaseDO::getF041n, reqVO.getF041n())
                .eqIfPresent(LrBaseDO::getMemo, reqVO.getMemo())
                .eqIfPresent(LrBaseDO::getF062n, reqVO.getF062n())
                .eqIfPresent(LrBaseDO::getF063n, reqVO.getF063n())
                .eqIfPresent(LrBaseDO::getF064n, reqVO.getF064n())
                .eqIfPresent(LrBaseDO::getF065n, reqVO.getF065n())
                .eqIfPresent(LrBaseDO::getF066n, reqVO.getF066n())
                .eqIfPresent(LrBaseDO::getF067n, reqVO.getF067n())
                .eqIfPresent(LrBaseDO::getF030n, reqVO.getF030n())
                .eqIfPresent(LrBaseDO::getF072n, reqVO.getF072n())
                .eqIfPresent(LrBaseDO::getF073n, reqVO.getF073n())
                .betweenIfPresent(LrBaseDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(LrBaseDO::getId));
    }

}